package com.lyy.entity.excel;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

/**
 * @author Liangyaoyun
 */
//头行高度
@HeadRowHeight(20)
//内容行高
@ContentRowHeight(10)
//列宽
@ColumnWidth(18)
@Data
public class UserExcel implements Serializable {
    @ExcelProperty(value = {"用户统计表", "用户主键"}, index = 0)
    private Integer userId;
    @ExcelProperty(value = {"用户统计表", "登录账号"}, index = 1)
    private String username;
    @ExcelProperty(value = {"用户统计表", "登录密码"}, index = 2)
    private String password;
    @ExcelProperty(value = {"用户统计表", "真实姓名"}, index = 3)
    private String realName;
    @ExcelProperty(value = {"用户统计表", "创建日期"}, index = 4)
    @DateTimeFormat("yyyy/MM/dd HH:mm:ss")
    private Date createTime;
    @ExcelIgnore
    @ExcelProperty(value = {"用户统计表", "修改日期"}, index = 5)
    @DateTimeFormat("yyyy/MM/dd HH:mm:ss")
    private Date modifyTime;
}
